home *** CD-ROM | disk | FTP | other *** search
/ Developer Source 4 / developer source - volume 4.iso / sysad / nov95 / vellt103.gif < prev   
Graphics Interchange Format  |  1996-06-11  |  252KB  |  842x1169  |  4-bit (15 colors)
Labels: text | parallel | number | document | screenshot | line
OCR: Table 3 Sample Spreadsheet: Model for Computing System Cost Effectiveness MEDIA TYPE BetaCam 3590 DIT 2000 DIT 4000 8mm 4mm MO CD-R 19mm VHS Archive Size (GB) 300 300 300 300 300 300 300 300 300 300 Time of Extended Cost (years) 1 1 1 1 1 1 1 1 1 1 Kilowatt-hour Cost $0.15 $0.15 $0.15 $0.15 $0.15 $0.15 $0.15 $0.15 $0.15 $0,15 Archives per Month 2 2 2 2 2 2 2 2 2 2 Restores per Month 1 1 1 1 1 1 1 1 Admin. Manhour Cost ($/hr) $50 $50 $50 $50 $50 50 50 50 50 50 Physical Space Cost ($/ft3/yr) $0.48 $0.48 $0.48 $0.48 $0.48 0.48 0.48 0.48 0.48 0.48 Archive Babysitting Time (min/hr) 10 10 10 10 10 10 10 10 10 10 Initial System Cost $130,000 $49,500 $40,000 $50,000 $35,000 $30,000 $40,000 $78,000 $120,000 $61,000 Percent of Total Cost 85% 38 50% 48% 50% 32% 10% 27% 72% Single Media Cost $120 $100 $35 $120 $15 22 80 12 200 23 Single Media Native Capacity (GB) 42 10 20 7 4 1.7 0.681 330 21 Support Compression? = n y y y y n Y Compression Factor Used I 1 1 1 1 1 1 Effective Media Capacity (GB) 42 10 10 20 7 4 1.7 0.68 330 21 System Media Capacity 25 10 28 26 60 72 180 500 1 48 System Total Data Capacity (GB) 1050 100 280 520 420 288 306 340.5 330 1008 Effective Media Cost/GB ($/GB) $2.86 $10.00 $3.50 $6.00 $2.14 $5.50 $47.06 $17.62 $0.61 $1.095 Number of Media per Archive 7 30 30 15 43 75 176 441 1 14 Media Cost per Archive ($) $840 $3000 $1050 $1800 $645 $1,650 $14,080 $5,292 $200 $322 Extended Media Cost ($) $20,160 $72,000 $25,200 $43,200 $15,480 $39,600 $337,920 $127,008 $4,800 $7,728 Percent of Total Cost (%) 13% 56% 31% 41% 22% 42% 80% 44% 4% Single Media Volume (in3) 56.09 ? 16.8 16.8 10.02 3.00 11.81 6.25 151.63 25.38 Media Data Density (in3/GB) 1.34 1.68 0.84 1.43 0.75 6.95 9.18 0.46 1.21 Extended Media Storage Space (ft3) 5.45 7.00 3.50 5.98 3.13 28.87 38.28 2.11 4.94 Extended Media Storage Cost ($) $2.62 ? $3.36 $1.68 $2.87 $1.50 $13.86 $18.38 $1.01 $2.37 Percent of Total Cost (%) 0% 7% 0% 0% 0% 0% 0% 0% 0% 0% Native System Thruput (MB/s) 12.0 9.0 2.5 3.0 2.0 2.0 2.2 3.0 15.0 2.0 Effect. System Thruput (MB/s) 12.0 9.0 2.5 3.0 2.0 2.0 2.2 3.0 15.0 2.0 Time to Write 1 Data Set (hr) 7.11 9.48 34.33 28.44 42.67 42.67 38.79 28.44 5.69 42.67 Archive Babysitting Cost ($) $177.78 $237.04 $853.33 $711.11 $1066.67 $1,067 $970 $711 $142 $1,067 Extended Babysitting Cost ($) $2133 $2844 $10240 $8533 $12800 $12,800 $11,636 $8,533 $1707 $12,800 Percent of Total Cost (%) 1% 2% 13% 8% 18% 14% 3% 3% 1% 15% System Volume (ft3) 6.78 4.23 7.03 7.03 9.3 2.76 29.77 6.51 3.55 42.77 Extended System Space Cost ($) $3.25 $2.03 $3.37 $3.37 $4.46 $1.32 $14.29 $3.12 $1.70 $20.53 Percent of Total Cost (%) 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% System Power Usage (watts) 350 300 300 300 300 300 200 200 600 1170 Extended Power Usage Cost ($) $22.89 $23.46 $63.40 $54.18 $77.22 $77.22 $47.29 $36.12 $34.63 $301.16 Percent of Total Cost (%) 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% Manhours per Cleaning (min) 5 5 5 5 5 5 5 5 5 Hours between Cleanings 30 100 1000 1000 30 20 5000 5000 30 30 Materials Cost per Cleaning (S) $2.08 $2.08 $4.00 $4.00 $2.08 $1.25 $0.00 $0.00 $2.08 $2.08 Maintenance Cost per Archive $4.44 $0.18 $0.84 $0.70 $26.65 $4.67 $0.10 $0.07 $3.55 $26.65 Extended System Maint Cost $53.30 $2.13 $10.04 $8.36 $319.83 $416 $1.16 $0.85 $42.64 $319 Percent of Total Cost (%) 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% Media Formatting Time (min/media) 0 0 0 0 0 2 1 0 0 Manpower Media Loading per Archive $92 $39 $394 $19: $564 $984 $2,603 $6,156 $13 $184 Ext'd Manpower Media Loading Cost $1,103 $4,725 $4,725 $2,363 $6,773 $11,813 $31,240 $73,868 $158 $2,205 Percent of Total Cost (%) 1% 4% 6% 2 % 9% 12% 7% 26% 0% 3% EXTENDED TOTAL COST ($) $153,478 $129,097 $80,245 $104,163 $70,457 $94,709 $420,873 $287,467 $126,744 $84,377 EXTENDED TOTAL COST PER DATA SET $6,395 $5,379 $3,344 $4,340 $2,936 $3,946 $17,536 $11,978 $5,281 $3,516 EXTENDED TOTAL COST/GB ($/GB) $21.32 $17.93 $11.15 $14.47 $9.79 $13.15 $58.45 $39.93 $17.60 $11.72